package com.novasoftware.novagooglemap.db;

import android.R.string;

public class TableCreate {
	
	public static String Student()
	{
		StringBuffer sql = new StringBuffer();
		sql.append("CREATE TABLE IF NOT EXISTS Student(");
		
		sql.append("  Id         integer PRIMARY KEY autoincrement,");
		sql.append("FirstName  varchar(50),");
		sql.append("LastName   varchar(50),");
		sql.append("Sex        varchar(50),");
		sql.append("  Age        int default 0,");
		sql.append("Phone      varchar(50),");
		sql.append("Address    varchar(50),");
		sql.append("GeoPoint   varchar(50),");
		sql.append("  [CreatedOn]      datetime default (datetime('now', 'localtime'))  ");
		sql.append(")");
		
		return sql.toString();
	}
	
	public static String Natatoria()
	{
		StringBuffer sqlBuffer= new StringBuffer();
		sqlBuffer.append("Create Table IF NOT EXISTS natatoria(");
		sqlBuffer.append("Id integer PRIMARY KEY autoincrement,");
		sqlBuffer.append("Name varchar(50),");
		sqlBuffer.append("Geopoint varchar(50),");
		sqlBuffer.append("[CreatedOn]      datetime default (datetime('now', 'localtime'))");
		sqlBuffer.append(")");
		
		return sqlBuffer.toString();
	}
 
	public static String NovaCategory()
	{
		StringBuffer sqlBuffer= new StringBuffer();
		sqlBuffer.append("Create Table IF NOT EXISTS NovaCategory(");
		sqlBuffer.append("Id  integer PRIMARY KEY autoincrement,");
		sqlBuffer.append("Name varchar(50),");
		sqlBuffer.append("ImageId  int default 0,");
		sqlBuffer.append("CaseStudy  int default 0");
		sqlBuffer.append(")");
		return sqlBuffer.toString();
	}
}
